When you copy or cut a cell and then paste it, you copy or move the entire cell, including formulas and their resulting values, and cell formats.
If the area you select to copy includes cells hidden by filtering, you copy only the visible cells. You cannot move data from a range that includes filtered rows. To move the data you must first turn off filtering.
To move the cells, click Cut .
To copy the cells, click Copy .
Note When you cut data, you can paste it only once, but if you copy data, you can paste it multiple times. If you want to paste the data in several locations, use the Copy button to copy the data.
Notes
Move or copy characters within a cell
To move the characters, click Cut .
To copy the characters, click Copy .